﻿using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
using System.Configuration;

namespace Tesla.DataAccess.DataAccessComponents
{
    public partial class TeslaDataContext
    {
        public TeslaDataContext()
            : base(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)
        {
            OnCreated();
        }

        partial void OnCreated()
        {
            this.CommandTimeout = int.Parse(ConfigurationManager.AppSettings["GADNCommandTimeout"]);
        }

        [Function(Name = "dbo.usp_DisplayAllEmployee")]
        public ISingleResult<usp_DisplayAllEmployeeResult> usp_DisplayAllEmployee(
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize, 
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(1)));
            return ((ISingleResult<usp_DisplayAllEmployeeResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_DisplayAllPhase")]
        public ISingleResult<usp_DisplayAllPhaseResult> usp_DisplayAllPhase(
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize,
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(1)));
            return ((ISingleResult<usp_DisplayAllPhaseResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_DisplayAllTask")]
        public ISingleResult<usp_DisplayAllTaskResult> usp_DisplayAllTask(
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize, 
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(1)));
            return ((ISingleResult<usp_DisplayAllTaskResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_DisplayAllProject")]
        public ISingleResult<usp_DisplayAllProjectResult> usp_DisplayAllProject(
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize,
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(1)));
            return ((ISingleResult<usp_DisplayAllProjectResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_SearchEmployeeByName")]
        public ISingleResult<usp_SearchEmployeeByNameResult> usp_SearchEmployeeByName(
            [Parameter(Name = "EmployeeFirstName", DbType = "NVarChar(200)")] string employeeFirstName, 
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize, 
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())),
                employeeFirstName, gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(2)));
            return ((ISingleResult<usp_SearchEmployeeByNameResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_SearchPhaseByName")]
        public ISingleResult<usp_SearchPhaseByNameResult> usp_SearchPhaseByName(
            [Parameter(Name = "PhaseCode", DbType = "NChar(5)")] string phaseCode,
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize,
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())),
                phaseCode, gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(2)));
            return ((ISingleResult<usp_SearchPhaseByNameResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_SearchProjectByName")]
        public ISingleResult<usp_SearchProjectByNameResult> usp_SearchProjectByName(
            [Parameter(Name = "ProjectCode", DbType = "NChar(5)")] string employeeFirstName,
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize,
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())),
                employeeFirstName, gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(2)));
            return ((ISingleResult<usp_SearchProjectByNameResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_SearchTaskByName")]
        public ISingleResult<usp_SearchTaskByNameResult> usp_SearchTaskByName(
            [Parameter(Name = "TaskCode", DbType = "NChar(5)")] string taskCode,
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize,
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())),
                taskCode, gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(2)));
            return ((ISingleResult<usp_SearchTaskByNameResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_ReadEmployeeByRowNumberRange")]
        public ISingleResult<usp_ReadEmployeeByRowNumberRangeResult> usp_ReadEmployeeByRowNumberRange(
            [Parameter(Name = "StartRecordNumber", DbType = "Int")] System.Nullable<int> startRecordNumber, 
            [Parameter(Name = "EndRecordNumber", DbType = "Int")] System.Nullable<int> endRecordNumber, 
            [Parameter(Name = "SortColName", DbType = "VarChar(30)")] string sortColName, 
            [Parameter(Name = "SortDirection", DbType = "VarChar(4)")] string sortDirection, 
            [Parameter(Name = "SearchString", DbType = "NVarChar(100)")] string searchString)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), startRecordNumber, endRecordNumber, sortColName, sortDirection, searchString);
            return ((ISingleResult<usp_ReadEmployeeByRowNumberRangeResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_ReadPhaseByRowNumberRange")]
        public ISingleResult<usp_ReadPhaseByRowNumberRangeResult> usp_ReadPhaseByRowNumberRange(
            [Parameter(Name = "StartRecordNumber", DbType = "Int")] System.Nullable<int> startRecordNumber,
            [Parameter(Name = "EndRecordNumber", DbType = "Int")] System.Nullable<int> endRecordNumber,
            [Parameter(Name = "SortColName", DbType = "VarChar(30)")] string sortColName,
            [Parameter(Name = "SortDirection", DbType = "VarChar(4)")] string sortDirection,
            [Parameter(Name = "SearchString", DbType = "NVarChar(100)")] string searchString)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), startRecordNumber, endRecordNumber, sortColName, sortDirection, searchString);
            return ((ISingleResult<usp_ReadPhaseByRowNumberRangeResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_ReadProjectByRowNumberRange")]
        public ISingleResult<usp_ReadProjectByRowNumberRangeResult> usp_ReadProjectByRowNumberRange(
            [Parameter(Name = "StartRecordNumber", DbType = "Int")] System.Nullable<int> startRecordNumber,
            [Parameter(Name = "EndRecordNumber", DbType = "Int")] System.Nullable<int> endRecordNumber,
            [Parameter(Name = "SortColName", DbType = "VarChar(30)")] string sortColName,
            [Parameter(Name = "SortDirection", DbType = "VarChar(4)")] string sortDirection,
            [Parameter(Name = "SearchString", DbType = "NVarChar(100)")] string searchString)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), startRecordNumber, endRecordNumber, sortColName, sortDirection, searchString);
            return ((ISingleResult<usp_ReadProjectByRowNumberRangeResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_ReadTaskByRowNumberRange")]
        public ISingleResult<usp_ReadTaskByRowNumberRangeResult> usp_ReadTaskByRowNumberRange(
            [Parameter(Name = "StartRecordNumber", DbType = "Int")] System.Nullable<int> startRecordNumber,
            [Parameter(Name = "EndRecordNumber", DbType = "Int")] System.Nullable<int> endRecordNumber,
            [Parameter(Name = "SortColName", DbType = "VarChar(30)")] string sortColName,
            [Parameter(Name = "SortDirection", DbType = "VarChar(4)")] string sortDirection,
            [Parameter(Name = "SearchString", DbType = "NVarChar(100)")] string searchString)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), startRecordNumber, endRecordNumber, sortColName, sortDirection, searchString);
            return ((ISingleResult<usp_ReadTaskByRowNumberRangeResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_DisplayAllClient")]
        public ISingleResult<usp_DisplayAllClientResult> usp_DisplayAllClient(
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize,
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(1)));
            return ((ISingleResult<usp_DisplayAllClientResult>)(result.ReturnValue));
        }
        [Function(Name = "dbo.usp_SearchClientByName")]
        public ISingleResult<usp_SearchClientByNameResult> usp_SearchClientByName(
            [Parameter(Name = "ClientName", DbType = "NChar(50)")] string clientName,
            [Parameter(Name = "GridSize", DbType = "Int")] System.Nullable<int> gridSize,
            [Parameter(Name = "TotalRecordCount", DbType = "Int")] ref System.Nullable<int> totalRecordCount)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())),
                clientName, gridSize, totalRecordCount);
            totalRecordCount = ((System.Nullable<int>)(result.GetParameterValue(2)));
            return ((ISingleResult<usp_SearchClientByNameResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_ReadClientByRowNumberRange")]
        public ISingleResult<usp_ReadClientByRowNumberRangeResult> usp_ReadClientByRowNumberRange(
            [Parameter(Name = "StartRecordNumber", DbType = "Int")] System.Nullable<int> startRecordNumber,
            [Parameter(Name = "EndRecordNumber", DbType = "Int")] System.Nullable<int> endRecordNumber,
            [Parameter(Name = "SortColName", DbType = "VarChar(30)")] string sortColName,
            [Parameter(Name = "SortDirection", DbType = "VarChar(4)")] string sortDirection,
            [Parameter(Name = "SearchString", DbType = "NVarChar(100)")] string searchString)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), startRecordNumber, endRecordNumber, sortColName, sortDirection, searchString);
            return ((ISingleResult<usp_ReadClientByRowNumberRangeResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_ReadAllClientParents")]
        public ISingleResult<usp_ReadAllClientParentsResult> usp_ReadAllClientParents()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<usp_ReadAllClientParentsResult>)(result.ReturnValue));
        }

        [Function(Name = "dbo.usp_ReadAllOperatingUnits")]
        public ISingleResult<usp_ReadAllOperatingUnitsResult> usp_ReadAllOperatingUnits()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<usp_ReadAllOperatingUnitsResult>)(result.ReturnValue));
        }

        [global::System.Data.Linq.Mapping.FunctionAttribute(Name = "dbo.usp_ReadProjectsForClient")]
        public ISingleResult<usp_ReadProjectsForClientResult> usp_ReadProjectsForClient([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "ClientID", DbType = "Int")] System.Nullable<int> clientID)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), clientID);
            return ((ISingleResult<usp_ReadProjectsForClientResult>)(result.ReturnValue));
        }

        [global::System.Data.Linq.Mapping.FunctionAttribute(Name = "dbo.usp_ReadAllProjects")]
        public ISingleResult<usp_ReadAllProjectsResult> usp_ReadAllProjects()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<usp_ReadAllProjectsResult>)(result.ReturnValue));
        }

        [global::System.Data.Linq.Mapping.FunctionAttribute(Name = "dbo.usp_ReadAllTaskTypes")]
        public ISingleResult<usp_ReadAllTaskTypesResult> usp_ReadAllTaskTypes()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<usp_ReadAllTaskTypesResult>)(result.ReturnValue));
        }

        [global::System.Data.Linq.Mapping.FunctionAttribute(Name = "dbo.usp_ReadAllTasks")]
        public ISingleResult<usp_ReadAllTasksResult> usp_ReadAllTasks([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "TaskID", DbType = "Int")] System.Nullable<int> taskID)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), taskID);
            return ((ISingleResult<usp_ReadAllTasksResult>)(result.ReturnValue));
        }

        [global::System.Data.Linq.Mapping.FunctionAttribute(Name = "dbo.usp_ReadAllPhases")]
        public ISingleResult<usp_ReadAllPhasesResult> usp_ReadAllPhases()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<usp_ReadAllPhasesResult>)(result.ReturnValue));
        }
    }

    public partial class usp_ReadAllTaskTypesResult
    {

        private int _TaskTypeID;

        private string _TaskTypeCode;

        public usp_ReadAllTaskTypesResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskTypeID", DbType = "Int NOT NULL")]
        public int TaskTypeID
        {
            get
            {
                return this._TaskTypeID;
            }
            set
            {
                if ((this._TaskTypeID != value))
                {
                    this._TaskTypeID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskTypeCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskTypeCode
        {
            get
            {
                return this._TaskTypeCode;
            }
            set
            {
                if ((this._TaskTypeCode != value))
                {
                    this._TaskTypeCode = value;
                }
            }
        }
    }

    public partial class usp_ReadAllTasksResult
    {

        private int _TaskID;

        private string _TaskCode;

        public usp_ReadAllTasksResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskID", DbType = "Int NOT NULL")]
        public int TaskID
        {
            get
            {
                return this._TaskID;
            }
            set
            {
                if ((this._TaskID != value))
                {
                    this._TaskID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskCode
        {
            get
            {
                return this._TaskCode;
            }
            set
            {
                if ((this._TaskCode != value))
                {
                    this._TaskCode = value;
                }
            }
        }
    }

    public partial class usp_ReadAllPhasesResult
    {

        private int _PhaseID;

        private string _PhaseCode;

        public usp_ReadAllPhasesResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseID", DbType = "Int NOT NULL")]
        public int PhaseID
        {
            get
            {
                return this._PhaseID;
            }
            set
            {
                if ((this._PhaseID != value))
                {
                    this._PhaseID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string PhaseCode
        {
            get
            {
                return this._PhaseCode;
            }
            set
            {
                if ((this._PhaseCode != value))
                {
                    this._PhaseCode = value;
                }
            }
        }
    }

    public partial class usp_ReadAllProjectsResult
    {

        private int _ProjectID;

        private string _ProjectCode;

        public usp_ReadAllProjectsResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectID", DbType = "Int NOT NULL")]
        public int ProjectID
        {
            get
            {
                return this._ProjectID;
            }
            set
            {
                if ((this._ProjectID != value))
                {
                    this._ProjectID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }
    }
    
    public partial class usp_ReadProjectsForClientResult
    {

        private string _ProjectCode;

        private int _ProjectBillingType;

        private int _ProjectType;

        private System.DateTime _ProjectPlannedStartDate;

        private System.DateTime _ProjectPlannedEndDate;

        private System.Nullable<double> _ProjectCompletionPct;

        public usp_ReadProjectsForClientResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectBillingType", DbType = "Int NOT NULL")]
        public int ProjectBillingType
        {
            get
            {
                return this._ProjectBillingType;
            }
            set
            {
                if ((this._ProjectBillingType != value))
                {
                    this._ProjectBillingType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectType", DbType = "Int NOT NULL")]
        public int ProjectType
        {
            get
            {
                return this._ProjectType;
            }
            set
            {
                if ((this._ProjectType != value))
                {
                    this._ProjectType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedStartDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedStartDate
        {
            get
            {
                return this._ProjectPlannedStartDate;
            }
            set
            {
                if ((this._ProjectPlannedStartDate != value))
                {
                    this._ProjectPlannedStartDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedEndDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedEndDate
        {
            get
            {
                return this._ProjectPlannedEndDate;
            }
            set
            {
                if ((this._ProjectPlannedEndDate != value))
                {
                    this._ProjectPlannedEndDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCompletionPct", DbType = "Float")]
        public System.Nullable<double> ProjectCompletionPct
        {
            get
            {
                return this._ProjectCompletionPct;
            }
            set
            {
                if ((this._ProjectCompletionPct != value))
                {
                    this._ProjectCompletionPct = value;
                }
            }
        }
    }
    
    public partial class usp_DisplayAllEmployeeResult
    {
        private string _EmployeeName, _EmployeeManagerName, _EmployeeRoleName, _EmployeeDesignation;
        private int _EmployeeID;
        private DateTime _EmployeeDOB, _EmployeeDOJ;

        public usp_DisplayAllEmployeeResult()
        {
        }

        [Column(Storage = "_EmployeeID", DbType = "Int", CanBeNull = false)]
        public int EmployeeID
        {
            get
            {
                return this._EmployeeID;
            }
            set
            {
                if ((this._EmployeeID != value))
                {
                    this._EmployeeID = value;
                }
            }
        }

        [Column(Storage = "_EmployeeName", DbType = "NChar(150)", CanBeNull = false)]
        public string EmployeeName
        {
            get
            {
                return this._EmployeeName;
            }
            set
            {
                if ((this._EmployeeName != value))
                {
                    this._EmployeeName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeManagerName", DbType = "NChar(150)", CanBeNull = false)]
        public string EmployeeManagerName
        {
            get
            {
                return this._EmployeeManagerName;
            }
            set
            {
                if ((this._EmployeeManagerName != value))
                {
                    this._EmployeeManagerName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeRoleName", DbType = "NChar(100)", CanBeNull = false)]
        public string EmployeeRoleName
        {
            get
            {
                return this._EmployeeRoleName;
            }
            set
            {
                if ((this._EmployeeRoleName != value))
                {
                    this._EmployeeRoleName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeDesignation", DbType = "NChar(100)", CanBeNull = false)]
        public string EmployeeDesignation
        {
            get
            {
                return this._EmployeeDesignation;
            }
            set
            {
                if ((this._EmployeeDesignation != value))
                {
                    this._EmployeeDesignation = value;
                }
            }
        }


        [Column(Storage = "_EmployeeDOB", DbType = "smallDateTime", CanBeNull = true)]
        public DateTime EmployeeDOB
        {
            get
            {
                return this._EmployeeDOB;
            }
            set
            {
                if ((this._EmployeeDOB != value))
                {
                    this._EmployeeDOB = value;
                }
            }
        }

        [Column(Storage = "_EmployeeDOJ", DbType = "smallDateTime", CanBeNull = true)]
        public DateTime EmployeeDOJ
        {
            get
            {
                return this._EmployeeDOJ;
            }
            set
            {
                if ((this._EmployeeDOJ != value))
                {
                    this._EmployeeDOJ = value;
                }
            }
        }
    }

    public partial class usp_DisplayAllProjectResult
    {
        private string _ProjectCode;

        private int _ProjectBillingType, _ProjectID;

        private int _ProjectType;

        private System.DateTime _ProjectPlannedStartDate;

        private System.DateTime _ProjectPlannedEndDate;

        private System.Nullable<double> _ProjectCompletionPct;

        public usp_DisplayAllProjectResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectBillingType", DbType = "Int NOT NULL")]
        public int ProjectBillingType
        {
            get
            {
                return this._ProjectBillingType;
            }
            set
            {
                if ((this._ProjectBillingType != value))
                {
                    this._ProjectBillingType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectID", DbType = "Int NOT NULL")]
        public int ProjectID
        {
            get
            {
                return this._ProjectID;
            }
            set
            {
                if ((this._ProjectID != value))
                {
                    this._ProjectID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectType", DbType = "Int NOT NULL")]
        public int ProjectType
        {
            get
            {
                return this._ProjectType;
            }
            set
            {
                if ((this._ProjectType != value))
                {
                    this._ProjectType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedStartDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedStartDate
        {
            get
            {
                return this._ProjectPlannedStartDate;
            }
            set
            {
                if ((this._ProjectPlannedStartDate != value))
                {
                    this._ProjectPlannedStartDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedEndDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedEndDate
        {
            get
            {
                return this._ProjectPlannedEndDate;
            }
            set
            {
                if ((this._ProjectPlannedEndDate != value))
                {
                    this._ProjectPlannedEndDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCompletionPct", DbType = "Float")]
        public System.Nullable<double> ProjectCompletionPct
        {
            get
            {
                return this._ProjectCompletionPct;
            }
            set
            {
                if ((this._ProjectCompletionPct != value))
                {
                    this._ProjectCompletionPct = value;
                }
            }
        }
    }

    public partial class usp_DisplayAllPhaseResult
    {
        private string _ProjectCode, _PhaseCode, _PhaseShortDescription;

        private int _PhaseID;

        private System.Nullable<double> _PhaseCompletionPct;

        public usp_DisplayAllPhaseResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseID", DbType = "int NOT NULL", CanBeNull = false)]
        public int PhaseID
        {
            get
            {
                return this._PhaseID;
            }
            set
            {
                if ((this._PhaseID != value))
                {
                    this._PhaseID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string PhaseCode
        {
            get
            {
                return this._PhaseCode;
            }
            set
            {
                if ((this._PhaseCode != value))
                {
                    this._PhaseCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseShortDescription", DbType = "NChar(100) NOT NULL", CanBeNull = false)]
        public string PhaseShortDescription
        {
            get
            {
                return this._PhaseShortDescription;
            }
            set
            {
                if ((this._PhaseShortDescription != value))
                {
                    this._PhaseShortDescription = value;
                }
            }
        }


        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCompletionPct", DbType = "Float")]
        public System.Nullable<double> PhaseCompletionPct
        {
            get
            {
                return this._PhaseCompletionPct;
            }
            set
            {
                if ((this._PhaseCompletionPct != value))
                {
                    this._PhaseCompletionPct = value;
                }
            }
        }
    }

    public partial class usp_DisplayAllTaskResult
    {
        private string _TaskCode, _ParentTaskCode, _TaskDescription, _TaskTypeCode, _PhaseCode;

        private int _TaskID;


        public usp_DisplayAllTaskResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskID", DbType = "int NOT NULL", CanBeNull = false)]
        public int TaskID
        {
            get
            {
                return this._TaskID;
            }
            set
            {
                if ((this._TaskID != value))
                {
                    this._TaskID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskCode
        {
            get
            {
                return this._TaskCode;
            }
            set
            {
                if ((this._TaskCode != value))
                {
                    this._TaskCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskTypeCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskTypeCode
        {
            get
            {
                return this._TaskTypeCode;
            }
            set
            {
                if ((this._TaskTypeCode != value))
                {
                    this._TaskTypeCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string PhaseCode
        {
            get
            {
                return this._PhaseCode;
            }
            set
            {
                if ((this._PhaseCode != value))
                {
                    this._PhaseCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ParentTaskCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ParentTaskCode
        {
            get
            {
                return this._ParentTaskCode;
            }
            set
            {
                if ((this._ParentTaskCode != value))
                {
                    this._ParentTaskCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskDescription", DbType = "NChar(100) NOT NULL", CanBeNull = false)]
        public string TaskDescription
        {
            get
            {
                return this._TaskDescription;
            }
            set
            {
                if ((this._TaskDescription != value))
                {
                    this._TaskDescription = value;
                }
            }
        }
    }

    public partial class usp_ReadTaskByRowNumberRangeResult
    {
        private string _TaskCode, _ParentTaskCode, _TaskDescription, _TaskTypeCode, _PhaseCode;

        private int _TaskID;


        public usp_ReadTaskByRowNumberRangeResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskID", DbType = "int NOT NULL", CanBeNull = false)]
        public int TaskID
        {
            get
            {
                return this._TaskID;
            }
            set
            {
                if ((this._TaskID != value))
                {
                    this._TaskID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskCode
        {
            get
            {
                return this._TaskCode;
            }
            set
            {
                if ((this._TaskCode != value))
                {
                    this._TaskCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskTypeCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskTypeCode
        {
            get
            {
                return this._TaskTypeCode;
            }
            set
            {
                if ((this._TaskTypeCode != value))
                {
                    this._TaskTypeCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string PhaseCode
        {
            get
            {
                return this._PhaseCode;
            }
            set
            {
                if ((this._PhaseCode != value))
                {
                    this._PhaseCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ParentTaskCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ParentTaskCode
        {
            get
            {
                return this._ParentTaskCode;
            }
            set
            {
                if ((this._ParentTaskCode != value))
                {
                    this._ParentTaskCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskDescription", DbType = "NChar(100) NOT NULL", CanBeNull = false)]
        public string TaskDescription
        {
            get
            {
                return this._TaskDescription;
            }
            set
            {
                if ((this._TaskDescription != value))
                {
                    this._TaskDescription = value;
                }
            }
        }
    }

    public partial class usp_SearchTaskByNameResult
    {
        private string _TaskCode, _ParentTaskCode, _TaskDescription, _TaskTypeCode, _PhaseCode;

        private int _TaskID;


        public usp_SearchTaskByNameResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskID", DbType = "int NOT NULL", CanBeNull = false)]
        public int TaskID
        {
            get
            {
                return this._TaskID;
            }
            set
            {
                if ((this._TaskID != value))
                {
                    this._TaskID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskCode
        {
            get
            {
                return this._TaskCode;
            }
            set
            {
                if ((this._TaskCode != value))
                {
                    this._TaskCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskTypeCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string TaskTypeCode
        {
            get
            {
                return this._TaskTypeCode;
            }
            set
            {
                if ((this._TaskTypeCode != value))
                {
                    this._TaskTypeCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string PhaseCode
        {
            get
            {
                return this._PhaseCode;
            }
            set
            {
                if ((this._PhaseCode != value))
                {
                    this._PhaseCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ParentTaskCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ParentTaskCode
        {
            get
            {
                return this._ParentTaskCode;
            }
            set
            {
                if ((this._ParentTaskCode != value))
                {
                    this._ParentTaskCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_TaskDescription", DbType = "NChar(100) NOT NULL", CanBeNull = false)]
        public string TaskDescription
        {
            get
            {
                return this._TaskDescription;
            }
            set
            {
                if ((this._TaskDescription != value))
                {
                    this._TaskDescription = value;
                }
            }
        }
    }

    public partial class usp_SearchPhaseByNameResult
    {
        private string _ProjectCode, _PhaseCode, _PhaseShortDescription;

        private int _PhaseID;

        private System.Nullable<double> _PhaseCompletionPct;

        public usp_SearchPhaseByNameResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseID", DbType = "int NOT NULL", CanBeNull = false)]
        public int PhaseID
        {
            get
            {
                return this._PhaseID;
            }
            set
            {
                if ((this._PhaseID != value))
                {
                    this._PhaseID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string PhaseCode
        {
            get
            {
                return this._PhaseCode;
            }
            set
            {
                if ((this._PhaseCode != value))
                {
                    this._PhaseCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseShortDescription", DbType = "NChar(100) NOT NULL", CanBeNull = false)]
        public string PhaseShortDescription
        {
            get
            {
                return this._PhaseShortDescription;
            }
            set
            {
                if ((this._PhaseShortDescription != value))
                {
                    this._PhaseShortDescription = value;
                }
            }
        }


        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCompletionPct", DbType = "Float")]
        public System.Nullable<double> PhaseCompletionPct
        {
            get
            {
                return this._PhaseCompletionPct;
            }
            set
            {
                if ((this._PhaseCompletionPct != value))
                {
                    this._PhaseCompletionPct = value;
                }
            }
        }
    }

    public partial class usp_ReadPhaseByRowNumberRangeResult
    {
        private string _ProjectCode, _PhaseCode, _PhaseShortDescription;

        private int _PhaseID;

        private System.Nullable<double> _PhaseCompletionPct;

        public usp_ReadPhaseByRowNumberRangeResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseID", DbType = "int NOT NULL", CanBeNull = false)]
        public int PhaseID
        {
            get
            {
                return this._PhaseID;
            }
            set
            {
                if ((this._PhaseID != value))
                {
                    this._PhaseID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string PhaseCode
        {
            get
            {
                return this._PhaseCode;
            }
            set
            {
                if ((this._PhaseCode != value))
                {
                    this._PhaseCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseShortDescription", DbType = "NChar(100) NOT NULL", CanBeNull = false)]
        public string PhaseShortDescription
        {
            get
            {
                return this._PhaseShortDescription;
            }
            set
            {
                if ((this._PhaseShortDescription != value))
                {
                    this._PhaseShortDescription = value;
                }
            }
        }


        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_PhaseCompletionPct", DbType = "Float")]
        public System.Nullable<double> PhaseCompletionPct
        {
            get
            {
                return this._PhaseCompletionPct;
            }
            set
            {
                if ((this._PhaseCompletionPct != value))
                {
                    this._PhaseCompletionPct = value;
                }
            }
        }
    }

    public partial class usp_SearchProjectByNameResult
    {
        private string _ProjectCode;

        private int _ProjectBillingType, _ProjectID;

        private int _ProjectType;

        private System.DateTime _ProjectPlannedStartDate;

        private System.DateTime _ProjectPlannedEndDate;

        private System.Nullable<double> _ProjectCompletionPct;

        public usp_SearchProjectByNameResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectBillingType", DbType = "Int NOT NULL")]
        public int ProjectBillingType
        {
            get
            {
                return this._ProjectBillingType;
            }
            set
            {
                if ((this._ProjectBillingType != value))
                {
                    this._ProjectBillingType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectID", DbType = "Int NOT NULL")]
        public int ProjectID
        {
            get
            {
                return this._ProjectID;
            }
            set
            {
                if ((this._ProjectID != value))
                {
                    this._ProjectID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectType", DbType = "Int NOT NULL")]
        public int ProjectType
        {
            get
            {
                return this._ProjectType;
            }
            set
            {
                if ((this._ProjectType != value))
                {
                    this._ProjectType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedStartDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedStartDate
        {
            get
            {
                return this._ProjectPlannedStartDate;
            }
            set
            {
                if ((this._ProjectPlannedStartDate != value))
                {
                    this._ProjectPlannedStartDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedEndDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedEndDate
        {
            get
            {
                return this._ProjectPlannedEndDate;
            }
            set
            {
                if ((this._ProjectPlannedEndDate != value))
                {
                    this._ProjectPlannedEndDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCompletionPct", DbType = "Float")]
        public System.Nullable<double> ProjectCompletionPct
        {
            get
            {
                return this._ProjectCompletionPct;
            }
            set
            {
                if ((this._ProjectCompletionPct != value))
                {
                    this._ProjectCompletionPct = value;
                }
            }
        }
    }

    public partial class usp_ReadProjectByRowNumberRangeResult
    {
        private string _ProjectCode;

        private int _ProjectBillingType, _ProjectID;

        private int _ProjectType;

        private System.DateTime _ProjectPlannedStartDate;

        private System.DateTime _ProjectPlannedEndDate;

        private System.Nullable<double> _ProjectCompletionPct;

        public usp_ReadProjectByRowNumberRangeResult()
        {
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCode", DbType = "NChar(5) NOT NULL", CanBeNull = false)]
        public string ProjectCode
        {
            get
            {
                return this._ProjectCode;
            }
            set
            {
                if ((this._ProjectCode != value))
                {
                    this._ProjectCode = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectBillingType", DbType = "Int NOT NULL")]
        public int ProjectBillingType
        {
            get
            {
                return this._ProjectBillingType;
            }
            set
            {
                if ((this._ProjectBillingType != value))
                {
                    this._ProjectBillingType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectID", DbType = "Int NOT NULL")]
        public int ProjectID
        {
            get
            {
                return this._ProjectID;
            }
            set
            {
                if ((this._ProjectID != value))
                {
                    this._ProjectID = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectType", DbType = "Int NOT NULL")]
        public int ProjectType
        {
            get
            {
                return this._ProjectType;
            }
            set
            {
                if ((this._ProjectType != value))
                {
                    this._ProjectType = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedStartDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedStartDate
        {
            get
            {
                return this._ProjectPlannedStartDate;
            }
            set
            {
                if ((this._ProjectPlannedStartDate != value))
                {
                    this._ProjectPlannedStartDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectPlannedEndDate", DbType = "SmallDateTime NOT NULL")]
        public System.DateTime ProjectPlannedEndDate
        {
            get
            {
                return this._ProjectPlannedEndDate;
            }
            set
            {
                if ((this._ProjectPlannedEndDate != value))
                {
                    this._ProjectPlannedEndDate = value;
                }
            }
        }

        [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_ProjectCompletionPct", DbType = "Float")]
        public System.Nullable<double> ProjectCompletionPct
        {
            get
            {
                return this._ProjectCompletionPct;
            }
            set
            {
                if ((this._ProjectCompletionPct != value))
                {
                    this._ProjectCompletionPct = value;
                }
            }
        }
    }

    public partial class usp_SearchEmployeeByNameResult
    {
        private string _EmployeeName, _EmployeeManagerName, _EmployeeRoleName, _EmployeeDesignation;
        private int _EmployeeID;
        private DateTime _EmployeeDOB, _EmployeeDOJ;

        public usp_SearchEmployeeByNameResult()
        {
        }

        [Column(Storage = "_EmployeeID", DbType = "Int", CanBeNull = false)]
        public int EmployeeID
        {
            get
            {
                return this._EmployeeID;
            }
            set
            {
                if ((this._EmployeeID != value))
                {
                    this._EmployeeID = value;
                }
            }
        }

        [Column(Storage = "_EmployeeName", DbType = "NChar(150)", CanBeNull = false)]
        public string EmployeeName
        {
            get
            {
                return this._EmployeeName;
            }
            set
            {
                if ((this._EmployeeName != value))
                {
                    this._EmployeeName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeManagerName", DbType = "NChar(150)", CanBeNull = false)]
        public string EmployeeManagerName
        {
            get
            {
                return this._EmployeeManagerName;
            }
            set
            {
                if ((this._EmployeeManagerName != value))
                {
                    this._EmployeeManagerName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeRoleName", DbType = "NChar(100)", CanBeNull = false)]
        public string EmployeeRoleName
        {
            get
            {
                return this._EmployeeRoleName;
            }
            set
            {
                if ((this._EmployeeRoleName != value))
                {
                    this._EmployeeRoleName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeDesignation", DbType = "NChar(100)", CanBeNull = false)]
        public string EmployeeDesignation
        {
            get
            {
                return this._EmployeeDesignation;
            }
            set
            {
                if ((this._EmployeeDesignation != value))
                {
                    this._EmployeeDesignation = value;
                }
            }
        }


        [Column(Storage = "_EmployeeDOB", DbType = "smallDateTime", CanBeNull = true)]
        public DateTime EmployeeDOB
        {
            get
            {
                return this._EmployeeDOB;
            }
            set
            {
                if ((this._EmployeeDOB != value))
                {
                    this._EmployeeDOB = value;
                }
            }
        }

        [Column(Storage = "_EmployeeDOJ", DbType = "smallDateTime", CanBeNull = true)]
        public DateTime EmployeeDOJ
        {
            get
            {
                return this._EmployeeDOJ;
            }
            set
            {
                if ((this._EmployeeDOJ != value))
                {
                    this._EmployeeDOJ = value;
                }
            }
        }
    }

    public partial class usp_ReadEmployeeByRowNumberRangeResult
    {
        private string _EmployeeName, _EmployeeManagerName, _EmployeeRoleName, _EmployeeDesignation;
        private int _EmployeeID;
        private DateTime _EmployeeDOB, _EmployeeDOJ;

        public usp_ReadEmployeeByRowNumberRangeResult()
        {
        }

        [Column(Storage = "_EmployeeID", DbType = "Int", CanBeNull = false)]
        public int EmployeeID
        {
            get
            {
                return this._EmployeeID;
            }
            set
            {
                if ((this._EmployeeID != value))
                {
                    this._EmployeeID = value;
                }
            }
        }

        [Column(Storage = "_EmployeeName", DbType = "NChar(150)", CanBeNull = false)]
        public string EmployeeName
        {
            get
            {
                return this._EmployeeName;
            }
            set
            {
                if ((this._EmployeeName != value))
                {
                    this._EmployeeName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeManagerName", DbType = "NChar(150)", CanBeNull = false)]
        public string EmployeeManagerName
        {
            get
            {
                return this._EmployeeManagerName;
            }
            set
            {
                if ((this._EmployeeManagerName != value))
                {
                    this._EmployeeManagerName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeRoleName", DbType = "NChar(100)", CanBeNull = false)]
        public string EmployeeRoleName
        {
            get
            {
                return this._EmployeeRoleName;
            }
            set
            {
                if ((this._EmployeeRoleName != value))
                {
                    this._EmployeeRoleName = value;
                }
            }
        }

        [Column(Storage = "_EmployeeDesignation", DbType = "NChar(100)", CanBeNull = false)]
        public string EmployeeDesignation
        {
            get
            {
                return this._EmployeeDesignation;
            }
            set
            {
                if ((this._EmployeeDesignation != value))
                {
                    this._EmployeeDesignation = value;
                }
            }
        }


        [Column(Storage = "_EmployeeDOB", DbType = "smallDateTime", CanBeNull = true)]
        public DateTime EmployeeDOB
        {
            get
            {
                return this._EmployeeDOB;
            }
            set
            {
                if ((this._EmployeeDOB != value))
                {
                    this._EmployeeDOB = value;
                }
            }
        }

        [Column(Storage = "_EmployeeDOJ", DbType = "smallDateTime", CanBeNull = true)]
        public DateTime EmployeeDOJ
        {
            get
            {
                return this._EmployeeDOJ;
            }
            set
            {
                if ((this._EmployeeDOJ != value))
                {
                    this._EmployeeDOJ = value;
                }
            }
        }
    }

    public partial class usp_DisplayAllClientResult
    {
        private string _ClientName, _ClientParentName, _ClientGeo, _Client_OU;
        private int _ClientID;

        public usp_DisplayAllClientResult()
        {
        }

        [Column(Storage = "_ClientID", DbType = "Int", CanBeNull = false)]
        public int ClientID
        {
            get
            {
                return this._ClientID;
            }
            set
            {
                if ((this._ClientID != value))
                {
                    this._ClientID = value;
                }
            }
        }

        [Column(Storage = "_ClientName", DbType = "NChar(50)", CanBeNull = false)]
        public string ClientName
        {
            get
            {
                return this._ClientName;
            }
            set
            {
                if ((this._ClientName != value))
                {
                    this._ClientName = value;
                }
            }
        }

        [Column(Storage = "_ClientParentName", DbType = "NChar(50)", CanBeNull = false)]
        public string ClientParentName
        {
            get
            {
                return this._ClientParentName;
            }
            set
            {
                if ((this._ClientParentName != value))
                {
                    this._ClientParentName = value;
                }
            }
        }

        [Column(Storage = "_ClientGeo", DbType = "NChar(4)", CanBeNull = false)]
        public string ClientGeo
        {
            get
            {
                return this._ClientGeo;
            }
            set
            {
                if ((this._ClientGeo != value))
                {
                    this._ClientGeo = value;
                }
            }
        }

        [Column(Storage = "_Client_OU", DbType = "NChar(10)", CanBeNull = false)]
        public string Client_OU
        {
            get
            {
                return this._Client_OU;
            }
            set
            {
                if ((this._Client_OU != value))
                {
                    this._Client_OU = value;
                }
            }
        }


    }

    public partial class usp_SearchClientByNameResult
    {
        private string _ClientName, _ClientParentName, _ClientGeo, _Client_OU;
        private int _ClientID;

        public usp_SearchClientByNameResult()
        {
        }

        [Column(Storage = "_ClientID", DbType = "Int", CanBeNull = false)]
        public int ClientID
        {
            get
            {
                return this._ClientID;
            }
            set
            {
                if ((this._ClientID != value))
                {
                    this._ClientID = value;
                }
            }
        }

        [Column(Storage = "_ClientName", DbType = "NChar(50)", CanBeNull = false)]
        public string ClientName
        {
            get
            {
                return this._ClientName;
            }
            set
            {
                if ((this._ClientName != value))
                {
                    this._ClientName = value;
                }
            }
        }

        [Column(Storage = "_ClientParentName", DbType = "NChar(50)", CanBeNull = false)]
        public string ClientParentName
        {
            get
            {
                return this._ClientParentName;
            }
            set
            {
                if ((this._ClientParentName != value))
                {
                    this._ClientParentName = value;
                }
            }
        }

        [Column(Storage = "_ClientGeo", DbType = "NChar(4)", CanBeNull = false)]
        public string ClientGeo
        {
            get
            {
                return this._ClientGeo;
            }
            set
            {
                if ((this._ClientGeo != value))
                {
                    this._ClientGeo = value;
                }
            }
        }

        [Column(Storage = "_Client_OU", DbType = "NChar(10)", CanBeNull = false)]
        public string Client_OU
        {
            get
            {
                return this._Client_OU;
            }
            set
            {
                if ((this._Client_OU != value))
                {
                    this._Client_OU = value;
                }
            }
        }


    }

    public partial class usp_ReadClientByRowNumberRangeResult
    {
        private string _ClientName, _ClientParentName, _ClientGeo, _Client_OU;
        private int _ClientID;

        public usp_ReadClientByRowNumberRangeResult()
        {
        }

        [Column(Storage = "_ClientID", DbType = "Int", CanBeNull = false)]
        public int ClientID
        {
            get
            {
                return this._ClientID;
            }
            set
            {
                if ((this._ClientID != value))
                {
                    this._ClientID = value;
                }
            }
        }

        [Column(Storage = "_ClientName", DbType = "NChar(50)", CanBeNull = false)]
        public string ClientName
        {
            get
            {
                return this._ClientName;
            }
            set
            {
                if ((this._ClientName != value))
                {
                    this._ClientName = value;
                }
            }
        }

        [Column(Storage = "_ClientParentName", DbType = "NChar(50)", CanBeNull = false)]
        public string ClientParentName
        {
            get
            {
                return this._ClientParentName;
            }
            set
            {
                if ((this._ClientParentName != value))
                {
                    this._ClientParentName = value;
                }
            }
        }

        [Column(Storage = "_ClientGeo", DbType = "NChar(4)", CanBeNull = false)]
        public string ClientGeo
        {
            get
            {
                return this._ClientGeo;
            }
            set
            {
                if ((this._ClientGeo != value))
                {
                    this._ClientGeo = value;
                }
            }
        }

        [Column(Storage = "_Client_OU", DbType = "NChar(10)", CanBeNull = false)]
        public string Client_OU
        {
            get
            {
                return this._Client_OU;
            }
            set
            {
                if ((this._Client_OU != value))
                {
                    this._Client_OU = value;
                }
            }
        }


    }

    public partial class usp_ReadAllClientParentsResult
    {

        private int _ClientID;

        private string _ClientName;

        public usp_ReadAllClientParentsResult()
        {
        }

        [Column(Storage = "_ClientID", DbType = "Int NOT NULL")]
        public int ClientID
        {
            get
            {
                return this._ClientID;
            }
            set
            {
                if ((this._ClientID != value))
                {
                    this._ClientID = value;
                }
            }
        }

        [Column(Storage = "_ClientName", DbType = "NChar(50) NOT NULL", CanBeNull = false)]
        public string ClientName
        {
            get
            {
                return this._ClientName;
            }
            set
            {
                if ((this._ClientName != value))
                {
                    this._ClientName = value;
                }
            }
        }
    }

    public partial class usp_ReadAllOperatingUnitsResult
    {

        private int _OperatingUnitID;

        private string _OperatingUnitDescription;

        public usp_ReadAllOperatingUnitsResult()
        {
        }

        [Column(Storage = "_OperatingUnitID", DbType = "Int NOT NULL")]
        public int OperatingUnitID
        {
            get
            {
                return this._OperatingUnitID;
            }
            set
            {
                if ((this._OperatingUnitID != value))
                {
                    this._OperatingUnitID = value;
                }
            }
        }

        [Column(Storage = "_OperatingUnitDescription", DbType = "NChar(10)")]
        public string OperatingUnitDescription
        {
            get
            {
                return this._OperatingUnitDescription;
            }
            set
            {
                if ((this._OperatingUnitDescription != value))
                {
                    this._OperatingUnitDescription = value;
                }
            }
        }
    }
 }







